| SyCounty |
| Logical Entity Name | SyCounty |
| Default Table Name | SyCounty |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SyCounty Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SyCountyID |
int | NO | ||
| Code | char(8) | YES | ||
| Descrip | varchar(40) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| Active | bit | NO | ||
| ModFlag | char(1) | NO | ||
| UserID | int | NO | ||
| ts | timestamp | YES | ||
| SyCampusGrpID | int | NO | ||
| County_FIPS | int | YES | ||
| State | char(2) | YES |
| SyCounty Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyCounty_SyCountyID_U_C_IDX | PrimaryKey | SyCountyID |
| SyCounty Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| AdLocation | Non-Identifying | One To Zero or More | FK_AdLocation_SyCountyID_SyCounty_SyCountyID | NO | YES | |||
| PlElectronicEmployer | Non-Identifying | One To Zero or More | FK_PlElectronicEmployer_SyCountyID_SyCounty_SyCountyID | NO | YES | |||
| SyCountyExternalMap | Non-Identifying | One To Zero or More | FK_SyCountyExternalMapSyCountyId_SyCountySyCountyId | NO | YES | |||
| SyOrganization | Non-Identifying | One To Zero or More | FK_SyOrganization_SyCountyID_SyCounty_SyCountyID | NO | YES | |||
| SyOrganizationContact | Non-Identifying | One To Zero or More | FK_SyOrganizationContact_SyCountyID_SyCounty_SyCountyID | NO | YES | |||
| SyPersonAddress | Non-Identifying | One To Zero or More | FK_SyPersonAddress_SyCountyId_SyCounty_SyCountyId | NO | YES | |||
| SyNexusOrganizationAddress | Non-Identifying | One To Zero or More | SyNexusOrganizationAddressSyCountyId_SyCountySyCountyId | NO | YES |
| SyCounty Check Constraints |
| Check Constraint Name | CheckConstraint |
| SyCounty Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group |
| SyCounty Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.County |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyCounty |
NO |
| SyCounty Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Addresses_Affiliations |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | System |
| SyCounty Data Movement Rules |
| Name | Type | Rule Text/Value |